sql server dba introduction

The original: Everyone is DBA (IV) SQL Server memory ManagementSQL Server's memory management is a huge topic that involves a number of concepts and techniques, such as the common Plan Cache, Buffer Pool, memory clerks, and so on. This article is only glimpse, which describes common memory management-related concepts.Before understanding memory management, the Sy

In a Microsoft SQL Server 2008 system, the database administrator (DB administration, referred to as DBA) is the most important role. The goal of the DBA is to ensure that the Microsoft SQL Server 2008 System runs normally and eff

The original: Everyone is a DBA (III) SQL Server SchedulerIn SQL Server, when a database is started, SQL Server creates a corresponding Task scheduler (Scheduler) for each physical CPU

Tags: des style blog http io ar color OS useThe original: Everyone is DBA (II) SQL Server MetadataA set of tables is maintained in SQL Server to store information about all objects, data types, constraints, configuration options, available resources, and so on in

Original: 2-year summary of SQL Server DBA tuning2 years SQL Server DBA Summary of tuningWhen I was 2 DBA I felt that there was something that needed to be shared with everyone to discu

In Microsoft SQL Server 2008, database administrators (DBA) are the most important roles. DBA's goal is to ensure that the Microsoft SQL Server 2008 system runs properly and efficiently. DBA is also the busiest job. Both Performan

. Also known as the action query language. Specific statements such as:Mysql> Delete from mysql.user where host= ' localhost ';Query OK, 2 rows affected (0.10 sec)Iii. Transaction Processing Language (TRL)Its statement ensures that all rows of the table affected by the DML statement are updated in a timely manner, and the TPL statements include Begin,transaction,commit and rollback. The main understanding of the latter two.Iv. Data Control Language (DCL)DCL Full Name (Data Control Language) It a

--Calculate space by page, have performance impact, basic accuracyexecsp_spaceusedGo ----Can @updateusage = ' true ' and will run DBCC UPDATEUSAGEexecsp_spaceused@updateusage = 'true'Go ----Displays the number of page and row count errors in the catalog view for a database and correctsDBCCUpdateusage ('Shyanglao')Query page already uses sizeResults such as:2. Data files2.1 Data File Size UseMaster--View all files and sizes in a databaseexecsp_helpfile--View all files in the database, path, st

Label:Original: SQL Server DBA work detailsIn a Microsoft SQL Server 2008 system, the database administrator, or DBA, is the most important role in the administration. The DBA's goal is to ensure that the Microsoft

In a Microsoft SQL Server 2008 system, the database administrator (DB administration, referred to as DBA) is the most important role. The goal of the DBA is to ensure that the Microsoft SQL Server 2008 System runs normally and eff

2YearSQL Server DBAOptimization Summary When I was a dBA for two years, I felt that some things needed to be shared and discussed with you. Book order 1. "in-depth analysis of SQL Server 2008 series" is the technical insider series of MSSQL 2005. I am also interested in version 2012. The technical insider series is my